US Renewable Natural Gas Analysis

Kweku Reginald Wade

04/28/2022

Introduction

Questions

Required Packages

Source Data

LFG Energy Project Data Files (March 2022)

#Read in data
landfillgas_raw = read_excel("Data/lmopdata.xlsx", sheet="LMOP Database")

Source: https://www.epa.gov/lmop/lmop-landfill-and-project-database

AgSTAR Livestock Anaerobic Digester Database

anaerobicdigesterfas_raw = read_excel("Data/agstar-livestock-ad-database.xlsx", sheet="Operational and Construction")

AgSTAR publishes updated data on this website periodically (generally, two times per year) to enhance public access to information and support the development of biogas recovery projects

Source: https://www.epa.gov/agstar/livestock-anaerobic-digester-database

RNG Facility Data

rng_facility_raw = read_csv("Data/RNG_Facilities.csv", show_col_types = FALSE)

Data Summary

LMOP Landfill and Landfill Gas Energy Project Database

names(landfillgas_raw)
##  [1] "GHGRP ID"                                               
##  [2] "Landfill ID"                                            
##  [3] "Landfill Name"                                          
##  [4] "State"                                                  
##  [5] "Physical Address"                                       
##  [6] "City"                                                   
##  [7] "County"                                                 
##  [8] "Zip Code"                                               
##  [9] "Latitude"                                               
## [10] "Longitude"                                              
## [11] "Ownership Type"                                         
## [12] "Landfill Owner Organization(s)"                         
## [13] "Year Landfill Opened"                                   
## [14] "Landfill Closure Year"                                  
## [15] "Current Landfill Status"                                
## [16] "Waste in Place (tons)"                                  
## [17] "Waste in Place Year"                                    
## [18] "LFG Collection System In Place?"                        
## [19] "LFG Collected (mmscfd)"                                 
## [20] "LFG Flared (mmscfd)"                                    
## [21] "Project ID"                                             
## [22] "Current Project Status"                                 
## [23] "Project Name"                                           
## [24] "Project Start Date"                                     
## [25] "Project Shutdown Date"                                  
## [26] "Project Type Category"                                  
## [27] "LFG Energy Project Type"                                
## [28] "RNG Delivery Method"                                    
## [29] "Actual MW Generation"                                   
## [30] "Rated MW Capacity"                                      
## [31] "LFG Flow to Project (mmscfd)"                           
## [32] "Current Year Emission Reductions (MMTCO2e/yr) - Direct" 
## [33] "Current Year Emission Reductions (MMTCO2e/yr) - Avoided"

AgSTAR Anaerobic Digester Database

names(anaerobicdigesterfas_raw)
##  [1] "Project Name"                                  
##  [2] "Project Type"                                  
##  [3] "City"                                          
##  [4] "County"                                        
##  [5] "State"                                         
##  [6] "Digester Type"                                 
##  [7] "Status"                                        
##  [8] "Year Operational"                              
##  [9] "Animal/Farm Type(s)"                           
## [10] "Cattle"                                        
## [11] "Dairy"                                         
## [12] "Poultry"                                       
## [13] "Swine"                                         
## [14] "Co-Digestion"                                  
## [15] "Biogas Generation Estimate (cu_ft/day)"        
## [16] "Electricity Generated (kWh/yr)"                
## [17] "Biogas End Use(s)"                             
## [18] "System Designer(s)_Developer(s) and Affiliates"
## [19] "Receiving Utility"                             
## [20] "Total Emission Reductions (MTCO2e/yr)"         
## [21] "Awarded USDA Funding?"
names(rng_facility_raw)
##  [1] "Facility Name"              "Category"                  
##  [3] "Type"                       "City"                      
##  [5] "State"                      "Start date"                
##  [7] "Gas Flow to project (scfm)" "Source"                    
##  [9] "Date updated"               "Latitude"                  
## [11] "Longitude"                  "x"                         
## [13] "y"

Data Cleaning

LMOP Landfill and Landfill Gas Energy Project Database

landfillgas_clean = clean_names(landfillgas_raw)
names(landfillgas_clean)
##  [1] "ghgrp_id"                                           
##  [2] "landfill_id"                                        
##  [3] "landfill_name"                                      
##  [4] "state"                                              
##  [5] "physical_address"                                   
##  [6] "city"                                               
##  [7] "county"                                             
##  [8] "zip_code"                                           
##  [9] "latitude"                                           
## [10] "longitude"                                          
## [11] "ownership_type"                                     
## [12] "landfill_owner_organization_s"                      
## [13] "year_landfill_opened"                               
## [14] "landfill_closure_year"                              
## [15] "current_landfill_status"                            
## [16] "waste_in_place_tons"                                
## [17] "waste_in_place_year"                                
## [18] "lfg_collection_system_in_place"                     
## [19] "lfg_collected_mmscfd"                               
## [20] "lfg_flared_mmscfd"                                  
## [21] "project_id"                                         
## [22] "current_project_status"                             
## [23] "project_name"                                       
## [24] "project_start_date"                                 
## [25] "project_shutdown_date"                              
## [26] "project_type_category"                              
## [27] "lfg_energy_project_type"                            
## [28] "rng_delivery_method"                                
## [29] "actual_mw_generation"                               
## [30] "rated_mw_capacity"                                  
## [31] "lfg_flow_to_project_mmscfd"                         
## [32] "current_year_emission_reductions_mmtco2e_yr_direct" 
## [33] "current_year_emission_reductions_mmtco2e_yr_avoided"

AgSTAR Anaerobic Digester Database

anaerobicdigesterfas_clean = clean_names(anaerobicdigesterfas_raw)
names(anaerobicdigesterfas_clean)
##  [1] "project_name"                                
##  [2] "project_type"                                
##  [3] "city"                                        
##  [4] "county"                                      
##  [5] "state"                                       
##  [6] "digester_type"                               
##  [7] "status"                                      
##  [8] "year_operational"                            
##  [9] "animal_farm_type_s"                          
## [10] "cattle"                                      
## [11] "dairy"                                       
## [12] "poultry"                                     
## [13] "swine"                                       
## [14] "co_digestion"                                
## [15] "biogas_generation_estimate_cu_ft_day"        
## [16] "electricity_generated_k_wh_yr"               
## [17] "biogas_end_use_s"                            
## [18] "system_designer_s_developer_s_and_affiliates"
## [19] "receiving_utility"                           
## [20] "total_emission_reductions_mtco2e_yr"         
## [21] "awarded_usda_funding"

RNG Facility Data

rng_facility_clean = clean_names(rng_facility_raw)
names(rng_facility_clean)
##  [1] "facility_name"            "category"                
##  [3] "type"                     "city"                    
##  [5] "state"                    "start_date"              
##  [7] "gas_flow_to_project_scfm" "source"                  
##  [9] "date_updated"             "latitude"                
## [11] "longitude"                "x"                       
## [13] "y"

EDA

LMOP Landfill and Landfill Gas Energy Project Database

landfill_name project_name state waste_in_place_tons lfg_energy_project_type project_start_date
Anchorage Regional Landfill Project #1 AK 10400368 Reciprocating Engine 2012-07-31
Anchorage Regional Landfill Project #1, Expansion #1 AK 10400368 Reciprocating Engine 2014-01-01
Capitol Disposal Landfill NA AK 950804 Unknown NA
Central Peninsula Landfill (CPL) Project #1 AK 1721799 Cogeneration 2023-01-01
Kodiak Island Borough Landfill NA AK 228688 Unknown NA

AgSTAR Anaerobic Digester Database

project_name state project_type animal_farm_type_s year_operational biogas_end_use_s
Cargill - Sandy River Farm Digester AR Farm Scale Swine 2008 Flared Full-time
Butterfield RNG Digester AZ Farm Scale Dairy 2021 Pipeline Gas
Caballero Dairy Farms Digester AZ Farm Scale Dairy 2022 Pipeline Gas
Paloma Dairy Digester AZ Farm Scale Dairy NA CNG
Stotz Southern Dairy Digester AZ Farm Scale Dairy 2011 Electricity

Project Breakdown

RNG Opearational Project Count by Year

RNG Operational Project Count by State

Landfill RNG Project Map

Ag Gas Project Map

RNG Facility Locations

Landfill RNG Project Forecast

Ag RNG Production Forecast

Bio Gas Generation Estimate/day (cubic ft)

Electricity Generation Estimate/year (KWH)

Demand

Project Count by End Use

Power Generation

Carbon Zero

Ag Emissions Reductions

Landfill Gas Emissions Reductions

Landfill Gas Emissions Avoidance